---
title: SAIF.Business.Tasks.Claim database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF Documentation
last_reviewed: 2026-08-21
library: SAIF.Business.Tasks.Claim
reference_type: embedded
---

# SAIF.Business.Tasks.Claim database tables

This page catalogs database tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [LEGACY_TASK_CODE](#legacy_task_code) | Oracle | `[unqualified]**` | R | Task templating reference data | `clsLegacyTaskCodeCollection` |

## LEGACY_TASK_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]**` — no owner prefix appears in the SQL, and the connecting Oracle user is supplied at runtime by the caller through `IDataPortalInfo`, so the owning schema cannot be resolved from this repository.** |
| **Purpose** | Task templating reference data — date offsets, notepad flag, category code, and text used when generating legacy-style tasks. |
| **Access pattern** | Direct inline SQL |
| **CRUD operations** | Read |
| **Key columns used** | `CREATE_DATE`, `CREATE_USER`, `DATE_DAYS_NUM`, `LEGACY_TASK_CODE`, `NOTEPAD_FLAG`, `TASK_CATEGORY_CODE`, `TEXT_DAYS_NUM`, `TASK_TEXT`, `UPDATE_DATE`, `UPDATE_USER`, `USE_RUNDATE_FLAG` |
| **Sequence** | N/A |
| **Related tables** | None discoverable — the query is an unjoined `SELECT *`.* |
| **Business objects** | `clsLegacyTaskCode`, `clsLegacyTaskCodeCollection` |

### Operations referencing this table
- [Load the legacy task code table](operations/op-16-load-legacy-task-code-table.md)

### Business rules referencing this table
- [BR-LTC-01: Legacy task codes are read-only](business-rules.md#br-ltc-01-legacy-task-codes-are-read-only)

### SQL referencing this table
- [SQL-002: Retrieve all legacy task codes](sql/SQL-002-legacy-task-code-select.md)

---

## Table relationship diagram

No cross-table relationships were identified in this library's SQL. There is exactly one addressable table (`LEGACY_TASK_CODE`), accessed by a single unjoined `SELECT *`; no JOIN clause, subquery, or multi-table statement exists in any scanned file.* Candidate cross-library linkage (not evidenced by SQL here): `LEGACY_TASK_CODE.TASK_CATEGORY_CODE` appears to correspond to the task category code domain consumed via `clsTaskCategoryCodeCollection`, and `LEGACY_TASK_CODE.LEGACY_TASK_CODE` is the natural key used by `clsLegacyTaskCodeCollection.Item(String)`.**

## Related documentation
- [Index](index.md)
- [Overview](overview.md)
- [Architecture](architecture.md)
- [Dependencies](dependencies.md)
- [Operations and processes](operations-processes.md)
- [Business rules](business-rules.md)
- [SQL catalog](sql/index.md)
- [Security and authorization](security-authorization.md)
- [API reference](api/index.md)

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or
> contextual evidence where direct confirmation was not available in source artifacts. Statements
> marked with ** could not be confirmed; treat as unknown until verified.

## Sources
- SAIF.Business.Tasks.Claim/clsLegacyTaskCodeCollection.vb
- SAIF.Business.Tasks.Claim/clsLegacyTaskCode.vb